<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/da_guo_li/article/details/80280289"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"【MySQL】漫谈MySQL体系结构 - 多多说happy的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>【MySQL】漫谈MySQL体系结构 - 多多说happy的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
            <script type="application/ld+json">{"@context":"https:\/\/ziyuan.baidu.com\/contexts\/cambrian.jsonld","@id":"https:\/\/blog.csdn.net\/da_guo_li\/article\/details\/80280289","appid":"1563894916825412","title":"\u3010MySQL\u3011\u6f2b\u8c08MySQL\u4f53\u7cfb\u7ed3\u6784 - \u591a\u591a\u8bf4happy\u7684\u535a\u5ba2","images":["https:\/\/img-blog.csdn.net\/20180511181449478?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70","https:\/\/img-blog.csdn.net\/20180511181017647?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70","https:\/\/img-blog.csdn.net\/20180511181553601?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70"],"pubDate":"2019-08-09T15:09:31"}</script>
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-2eefd34acf.min.css">
        <script type="text/javascript">
        var username = "da_guo_li";
        var blog_address = "https://blog.csdn.net/da_guo_li";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/da_guo_li/article/details/80280289"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin-yellow";
        // 收藏所需数据
        var articleTitle = "【MySQL】漫谈MySQL体系结构";
        var articleDesc = "背景  了解MySQL的架构图，对MySQL有一个整体的把握，对于以后深入理解MySQL是有很大帮助的。比如：很多查询优化工作实际上就是遵循一些原则让MySQL的优化器能够按照预想的合理方式运行。MySQL从概念上分为四层，如下图:这四层分别是网络连接层，服务层（核心层），存储引擎层，系统文件层。我们自顶向下开始讲解。网络接入层主要负责连接管理、授权认证、安全等等。  每个客户端连接都对...";
        // 第四范式所需数据
        var articleTitles = "【MySQL】漫谈MySQL体系结构 - 多多说happy的博客";
        
        var nickName = "da_guo_li";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/da_guo_li/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/da_guo_li/article/details/80280289";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">【MySQL】漫谈MySQL体系结构</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2018年05月11日 22:16:32</span>
                    <a class="follow-nickName" href="https://me.csdn.net/da_guo_li" target="_blank">da_guo_li</a>
                    <span class="read-count">阅读数 3095</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                                                    <svg class="icon" title="CSDN认证原创" aria-hidden="true"
                                 style="width:53px; height: 18px; vertical-align: -4px;">
                                <use xlink:href="#CSDN_Cert"></use>
                            </svg>
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/da_guo_li/article/details/80280289"> https://blog.csdn.net/da_guo_li/article/details/80280289</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                <div class="htmledit_views" id="content_views">
                                            <h3 style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Arial;background-color:rgb(166,255,153);">背景</h3><div>   <span style="font-size:14px;"> 了解MySQL的架构图，对MySQL有一个整体的把握，对于以后深入理解MySQL是有很大帮助的。比如：很多查询优化工作实际上就是遵循一些原则让MySQL的优化器能够按照预想的合理方式运行。 MySQL从概念上分为四层，如下图:</span></div><img src="https://img-blog.csdn.net/20180511181449478?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" /><p></p><div></div><div>这四层自顶向下分别是<span style="color:#ff0000;">网络连接层，服务层（核心层），存储引擎层，系统文件层</span><span style="color:#cc0000;">。</span>我们自顶向下开始讲解。</div><p></p><h3 style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Arial;background-color:rgb(166,255,153);">网络接入层</h3><div><span style="color:#ffffff;background-color:rgb(255,0,0);"><span style="font-size:14px;">作用</span></span></div><div><span style="font-size:14px;">     主要负责<span style="color:#ff6600;">连接管理、授权认证、安全</span>等等。每个客户端连接都对应着服务器上的一个线程。服务器上维护了一个线程池，避免为每个连接都创建销毁一个线程。当客户端连接到MySQL服务器时，服务器对其进行认证。可以通过用户名与密码认证，也可以通过SSL证书进行认证。登录认证后，服务器还会验证客户端是否有执行某个查询的操作权限。这一层并不是MySQL所特有的技术。</span></div><div><span style="font-size:14px;"><br /></span></div><div><span style="color:#ffffff;background-color:rgb(255,0,0);"><span style="font-size:14px;">为什么要设计成线程池？</span></span></div><p><span style="font-size:14px;">      在服务器内部，每个client都要有自己的线程。这个连接的查询都在一个单独的线程中执行。想象现实场景中数据库访问连接实在是太多了，如果每次连接都要创建一个线程，同时还要负责该线程的销毁。对于系统来说是多么大的消耗。由于线程是操作系统宝贵的资源。这时候线程池的出现就显得自然了，服务器缓存了线程，因此不需要为每个Client连接创建和销毁线程。 </span></p><h3 style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Arial;background-color:rgb(166,255,153);">服务层</h3><p><span style="font-size:14px;"><span style="color:#ffffff;background-color:rgb(255,0,0);">作用</span>    </span></p><p><span style="font-size:14px;">      第二层服务层是MySQL的核心，MySQL的核心服务层都在这一层，<span style="color:#ff6600;">查询解析，SQL执行计划分析，SQL执行计划优化，查询缓存</span>。以及跨存储引擎的功能都在这一层实现：存储过程，触发器，视图等。通过下图来观察服务层的内部结构：</span></p><p><img src="https://img-blog.csdn.net/20180511181017647?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" /></p><div></div><br /><p>                                                <span style="font-size:12px;">图中红色框中标出来的就是MySQL服务层内部执行的过程</span></p><p><span style="color:#ffffff;background-color:rgb(255,0,0);">下面来简单分析SQL语句在服务层中具体的流程：</span></p><div><span style="color:rgb(255,255,255);background-color:rgb(255,153,0);"><span style="font-size:14px;">查询缓存</span></span></div><div><span style="font-size:14px;">    在解析查询之前，服务器会检查查询缓存，如果能找到对应的查询，服务器不必进行查询解析、优化和执行的过程，直接返回缓存中的结果集。</span></div><div><span style="font-size:14px;"><br /></span></div><div><span style="text-indent:28px;font-family:Verdana, Arial, Tahoma;background-color:rgb(255,153,0);"><span style="color:rgb(255,255,255);"><span style="font-size:14px;">解析器与预处理器</span></span></span></div><div><span style="text-indent:28px;font-family:Verdana, Arial, Tahoma;"><span style="font-size:14px;">    MySQL会解析查询，并创建了一个内部数据结构（解析树）<span style="text-indent:0px;color:rgb(47,47,47);font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif;">。这个过程解析器主要通过语法规则来验证和解析。比如SQL中是否使用了错误的关键字或者关键字的顺序是否正确等等。预处理会根据MySQL的规则进一步检查解析树是否合法。比如要查询的数据表和数据列是否存在等。</span></span></span></div><div><span style="font-size:14px;"><br /></span></div><div><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif;background-color:rgb(255,153,0);"><span style="color:rgb(255,255,255);"><span style="font-size:14px;">查询优化器</span></span></span></div><div><span style="font-size:14px;"><span style="color:rgb(47,47,47);font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif;">    优化器将其转化成查询计划。多数情况下，一条查询可以有很多种执行方式，最后都返回相应的结果。优化器的作用就是找到这其中最好的执行计划。</span>优化器并不关心使用的什么存储引擎，但是存储引擎对优化查询是有影响的。优化器要求存储引擎提供容量或某个具体操作的开销信息来评估执行时间。</span></div><div><span style="font-size:14px;"><br /></span></div><div><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif;background-color:rgb(255,153,0);"><span style="color:rgb(255,255,255);"><span style="font-size:14px;">查询引擎</span></span></span></div><div><span style="color:rgb(47,47,47);font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif;"><span style="font-size:14px;">    在完成解析和优化阶段以后，MySQL会生成对应的执行计划，查询执行引擎根据执行计划给出的指令调用存储引擎的接口得出结果。</span></span></div><div><h3 style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Arial;background-color:rgb(166,255,153);">存储引擎层</h3><div><div><span style="color:rgb(255,255,255);background-color:rgb(255,0,0);"><span style="font-size:14px;">作用</span></span></div><div><span style="font-size:14px;">    <span style="color:#ff6600;">负责MySQL中数据的存储与提取。 服务器中的查询执行引擎通过API与存储引擎进行通信，通过接口屏蔽了不同存储引擎之间的差异。</span>MySQL采用插件式的存储引擎。MySQL为我们提供了许多存储引擎，每种存储引擎有不同的特点。我们可以根据不同的业务特点，选择最适合的存储引擎。如果对于存储引擎的性能不满意，可以通过修改源码来得到自己想要达到的性能。例如阿里巴巴的<span style="color:rgb(51,51,51);"><strong><span style="font-family:SimSun;">X-Engine，为了满足企业的需求facebook与google都对InnoDB存储引擎进行了扩充</span><span style="font-family:Verdana, Tahoma, 'BitStream vera Sans', Arial, Helvetica, sans-serif;">。</span></strong></span></span></div><div><span style="font-size:14px;">特点：</span></div><div><span style="font-size:14px;">    存储引擎是针对于表的而不是针对库的（一个库中不同表可以使用不同的存储引擎），<span style="line-height:26px;">服务器通过</span><span style="background-color:rgb(255,255,255);font-family:Calibri;line-height:26px;">API</span><span style="line-height:26px;">与存储引擎进行通信，用来屏蔽不同存储引擎之间的差异。</span></span></div><div><span style="font-size:14px;"><br /></span></div><div><span style="color:rgb(255,255,255);background-color:rgb(255,0,0);"><span style="font-size:14px;">下面大致介绍一下MySQL中常见的的存储引擎</span></span></div><div><span style="background-color:rgb(255,153,0);"><span style="color:#ffffff;"><span style="font-size:14px;">InnoDB</span></span></span></div><div><span style="font-size:14px;">    特点：支持事务，适合OLTP应用，假设没有什么特殊的需求，一般都采用InnoDB作为存储引擎。支持行级锁，从MySQL5.5.8开始,InnoDB存储引擎是默认的存储引擎。</span></div><div><span style="background-color:rgb(255,153,0);"><span style="color:rgb(255,255,255);"><span style="font-size:14px;">MyISAM</span></span></span></div><div><span style="font-size:14px;">    <span style="color:#ff6600;">特点</span></span></div><div><span style="font-size:14px;">        不支持事务，表锁设计，支持全文索引，主要应用于OLAP应用</span></div><div><span style="font-size:14px;">    <span style="color:#ff6600;">场景</span></span></div><div><span style="font-size:14px;">        在排序、分组等操作中，当数量超过一定大小之后，由查询优化器建立的临时表就是MyISAM类型</span></div><div><span style="font-size:14px;">        报表，数据仓库</span></div><div><span style="background-color:rgb(255,153,0);"><span style="color:rgb(255,255,255);"><span style="font-size:14px;">Memory</span></span></span></div><div><span style="font-size:14px;">    <span style="color:#ff6600;">特点</span></span></div><div><span style="font-size:14px;">        数据都存放在内存中，数据库重启或崩溃，表中的数据都将消失，但是标的结构还是会保存下来。默认使用Hash索引。</span></div><div><span style="font-size:14px;">    <span style="color:#ff6600;">场景</span></span></div><div><span style="font-size:14px;">        适合存储OLTP应用的临时数据或中间表。</span></div><div><span style="font-size:14px;">        用于查找或是映射表，例如邮编和地区的对应表。</span></div><div><span style="color:rgb(255,102,0);"><span style="font-size:14px;"><br /></span></span></div><div><span style="color:rgb(255,102,0);"><span style="font-size:14px;">除此之外还有CSV,Federated、Archive等等。后面会开一篇博客专门讲解MySQL存储引擎。</span></span><span style="font-size:14px;"> </span></div><h3 style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Arial;background-color:rgb(166,255,153);">系统文件层</h3><div><div><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif;background-color:rgb(255,0,0);"><span style="color:#ffffff;"><span style="font-size:14px;">作用</span></span></span></div><div><span style="color:rgb(47,47,47);font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif;"><span style="font-size:14px;">        该层主要是将数据库的数据存储在文件系统之上，并完成与存储引擎的交互。</span></span></div><div><span style="color:#ffffff;background-color:rgb(255,0,0);"><span style="font-size:14px;">MyISAM物理文件结构为</span></span></div><span style="font-size:14px;">为了掩饰我先建一个MyISAM存储引擎的表：</span><p><img src="https://img-blog.csdn.net/20180511181553601?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" /></p><p><span style="font-size:14px;">进入MySQL数据存储目录查看数据表在文件上的体现：</span><br /></p><p><img src="https://img-blog.csdn.net/20180511181650644?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" /><br /></p><div style="padding:0px;margin-top:1em;margin-bottom:1em;background-color:rgb(255,255,255);"><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif, SimHei, SimSun;line-height:26px;"><span style="font-size:14px;"><span style="color:#ff6600;">.frm文件：</span>与表相关的元数据信息都存放在frm文件，包括表结构的定义信息等。</span></span></div><div style="padding:0px;background-color:rgb(255,255,255);margin-top:1em;margin-bottom:1em;"><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif, SimHei, SimSun;line-height:26px;"><span style="font-size:14px;"><span style="color:#ff6600;">.MYD文件：</span>MyISAM存储引擎专用，用于存储MyISAM表的数据</span></span></div><div style="padding:0px;background-color:rgb(255,255,255);margin-top:1em;margin-bottom:1em;"><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif, SimHei, SimSun;line-height:26px;"><span style="font-size:14px;"><span style="color:#ff6600;">.MYI文件：</span>MyISAM存储引擎专用，用于存储MyISAM表的索引相关信息</span></span></div><div><span style="color:#ffffff;background-color:rgb(255,0,0);"><span style="font-size:14px;">InnoDB物理文件结构</span></span></div><p><span style="font-size:14px;">先建两个InnoD存储引擎的表：</span></p><p><img src="https://img-blog.csdn.net/20180511181730604?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" /></p><p><img src="https://img-blog.csdn.net/20180511182654466?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" /><br /></p><p><span style="font-size:14px;">进入MySQL数据存储目录查看数据表在文件上的体现：</span></p><p><img src="https://img-blog.csdn.net/20180511182902701?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RhX2d1b19saQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" alt="" /><br /></p><div><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif, SimHei, SimSun;"><span style="background-color:rgb(255,255,255);"><span style="font-size:14px;">注意上面的每个表都有一个*.frm与*.ibd后缀文件他们的作用分别是：</span></span></span></div><div><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif, SimHei, SimSun;background-color:rgb(255,255,255);"><span style="font-size:14px;"><span style="color:#ff6600;">.frm文件：</span>与表相关的元数据信息都存放在frm文件，包括表结构的定义信息等。</span></span></div><span style="font-family:'PingFang SC';"><span style="font-size:14px;"><span style="color:#ff6600;">.ibd文件：</span><span style="color:rgb(51,51,51);font-family:'PingFang SC';">存放innodb表的数据文件。</span></span></span></div><div><span style="font-family:'PingFang SC';color:#333333;"><span style="font-size:14px;"><br /></span></span><div><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif;"><span style="font-size:14px;"><span style="font-family:'PingFang SC';background-color:rgb(255,0,0);"><span style="color:#ffffff;">除了.ibd文件InnoDB还有一种文件的存储格式为.ibdata文件，那么他们之间有什么区别呢？</span></span><span style="color:#2f2f2f;"> </span></span></span></div><div><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif;"><span style="font-size:14px;"><span style="color:rgb(51,51,51);font-family:'PingFang SC';">这两种文件都是存放innodb数据的文件，之所以用两种文件来存放innodb的数据，是因为<span style="color:rgb(51,51,51);font-family:'PingFang SC';">InnoDB</span>的数据存储方式能够通过配置来决定是使用</span><span style="color:rgb(51,51,51);font-family:'PingFang SC';"><strong>共享表空间</strong></span><span style="color:rgb(51,51,51);font-family:'PingFang SC';">存放存储数据，还是用</span><span style="color:rgb(51,51,51);font-family:'PingFang SC';"><strong>独享表空间</strong></span><span style="font-family:'PingFang SC';"><span style="color:#333333;">存放存储数据。独享表空间存储方式使用.ibd文件，并且每个表一个ibd文件。共享表空间存储方式采用.ibdata文件，所有的表共同使用一个ibdata文件，即所有的数据文件都存在一个文件中。决定使用哪种表的存储方式可以通过</span><span style="font-family:'-apple-system', 'SF UI Text', Arial, 'PingFang SC', 'Hiragino Sans GB', 'Microsoft YaHei', 'WenQuanYi Micro Hei', sans-serif, SimHei, SimSun;line-height:26px;"><span style="color:#333333;">mysql的配置文件中 innodb_file_per_table选项来指定。</span><span style="color:#ff6600;">InnoDB默认使用的是独享表的存储方式，这种方式的好处是当数据库产生大量文件碎片的时，整理磁盘碎片对线上运行环境的影响较小。</span></span></span></span></span></div></div></div></div>                                    </div>
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/da_guo_li/article/details/80280289","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/da_guo_li/article/details/80280289","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="80280289">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_40792878/article/details/84917994","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_40792878/article/details/84917994","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_40792878/article/details/84917994" target="_blank" title="Mysql的体系结构和运行机理 --04">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>的<em>体系结构</em>和运行机理 --04		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-09</span>
				<span class="read-num hover-hide">
					阅读数 
					385</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_40792878/article/details/84917994" target="_blank" title="Mysql的体系结构和运行机理 --04">
				<span class="desc oneline">一、Mysql的体系结构整体图​​​​上图解析：1.Connector：接入方支持多种协议2.ManagementServeices&amp;amp;amp;amp;Utilities：系统管理和控制工具，m...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_40792878">来自：	<span class="blog_title"> Visonws的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/baidu_30994081/article/details/79753779","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/baidu_30994081/article/details/79753779","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/baidu_30994081/article/details/79753779" target="_blank" title="MySql体系架构（一）">
		<h4 class="text-truncate oneline">
				<em>MySql</em>体系架构（一）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-30</span>
				<span class="read-num hover-hide">
					阅读数 
					415</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/baidu_30994081/article/details/79753779" target="_blank" title="MySql体系架构（一）">
				<span class="desc oneline">定义数据库和实例：数据库：物理操作系统文件或其他形式类型文件的集合数据库实例：它是来操作数据库文件的，由后台线程以及一块共享内存区组成体系架构：（1）Connectors：不同语言中与SQL的交互（2...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/baidu_30994081">来自：	<span class="blog_title"> 黑子</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_42774383/article/details/81697346","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_42774383/article/details/81697346","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42774383/article/details/81697346" target="_blank" title="庖丁解牛之MySQL体系结构">
		<h4 class="text-truncate oneline">
				庖丁解牛之<em>MySQL</em><em>体系结构</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-15</span>
				<span class="read-num hover-hide">
					阅读数 
					150</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42774383/article/details/81697346" target="_blank" title="庖丁解牛之MySQL体系结构">
				<span class="desc oneline">一、MySQL简介1、MySQL是全球最普及的开源数据库，MySQL代表了Oracle所提供的同类产品中最出色的，面向基于web的应用程序数据库解决方案，是嵌入式数据库的不错选择。2、MySQL连接器...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42774383">来自：	<span class="blog_title"> 吴用的博客很有用啊！！！</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/happylee6688/article/details/47150515","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/happylee6688/article/details/47150515","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/happylee6688/article/details/47150515" target="_blank" title="带你认识 MySQL 之 MySQL 体系结构">
		<h4 class="text-truncate oneline">
				带你认识 <em>MySQL</em> 之 <em>MySQL</em> <em>体系结构</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-30</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/happylee6688/article/details/47150515" target="_blank" title="带你认识 MySQL 之 MySQL 体系结构">
				<span class="desc oneline">序最近一直在忙项目，各种加班加点，项目上线，渐渐的没有了学习的时间。这不，刚这几天才能抽出点时间，忙里偷闲，正在看一本数据库的书籍，相信很多小伙伴们也都看过——《MySQL技术内幕：InnoDB存储引...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/happylee6688">来自：	<span class="blog_title"> 紫羽风的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-78","con":",,"}' data-track-click='{"mod":"kp_popu_59-78","con":",,"}' data-report-view='{"mod":"kp_popu_59-78","keyword":""}' data-report-click='{"mod":"kp_popu_59-78","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3491668",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/w892824196/article/details/79759787","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/w892824196/article/details/79759787","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/w892824196/article/details/79759787" target="_blank" title="MySQL体系结构图详解">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>体系结构</em>图详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-30</span>
				<span class="read-num hover-hide">
					阅读数 
					3999</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/w892824196/article/details/79759787" target="_blank" title="MySQL体系结构图详解">
				<span class="desc oneline">体系结构图如下:连接层思想为解决资源的频繁分配﹑释放所造成的问题，为数据库连接建立一个“缓冲池”。原理预先在缓冲池中放入一定数量的连接，当需要建立数据库连接时，只需从“缓冲池”中取出一个，使用完毕之后...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/w892824196">来自：	<span class="blog_title"> Data & Analysis</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_614","dest":"https://download.csdn.net/download/xiaoenxiaoen/10847991","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_614","dest":"https://download.csdn.net/download/xiaoenxiaoen/10847991","strategy":"BlogCommendFromBaidu","index":"5"}'>
		<a href="https://download.csdn.net/download/xiaoenxiaoen/10847991" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>mysql</em><em>体系结构</em>					</h4>
					<span class="data float-right">12-13</span>
				</div>
				<div class="desc oneline">
						数据库-mysql-体系结构-炼数成金-郭一军-itpub- 。。。				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/dj673344908/article/details/80501175","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/dj673344908/article/details/80501175","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/dj673344908/article/details/80501175" target="_blank" title="MySQL体系结构">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>体系结构</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-29</span>
				<span class="read-num hover-hide">
					阅读数 
					213</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/dj673344908/article/details/80501175" target="_blank" title="MySQL体系结构">
				<span class="desc oneline">一、MySQL体系结构体系结构如图：从上图我们可以看出，mysql由以下几部分组成：1.连接池组件2.管理服务和工具组件3.SQL接口组件4.查询分析器组件5.优化器组件6.缓冲组件7.插件式存储引擎...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/dj673344908">来自：	<span class="blog_title"> Steven's blog</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_614","dest":"https://download.csdn.net/download/jihong10102006/10029418","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_614","dest":"https://download.csdn.net/download/jihong10102006/10029418","strategy":"BlogCommendFromBaidu","index":"7"}'>
		<a href="https://download.csdn.net/download/jihong10102006/10029418" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>MySQL</em><em>体系结构</em>高清.pdf版					</h4>
					<span class="data float-right">10-19</span>
				</div>
				<div class="desc oneline">
						MySQL体系结构高清.pdf版 Mysql 是由 SQL 接口，解析器，优化器，缓存，存储引擎组成的				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_614","dest":"https://download.csdn.net/download/weilisong99/9179773","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_614","dest":"https://download.csdn.net/download/weilisong99/9179773","strategy":"BlogCommendFromBaidu","index":"8"}'>
		<a href="https://download.csdn.net/download/weilisong99/9179773" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>MySql</em><em>体系结构</em>					</h4>
					<span class="data float-right">10-14</span>
				</div>
				<div class="desc oneline">
						更多是熟悉mysql数据库，深入的了解mysql的体系结构，对了解其底层知识有一定帮助				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
	<div class="recommend-item-box recommend-box-ident recommend-download-box clearfix" data-report-view='{"mod":"popu_614","dest":"https://download.csdn.net/download/machen_smiling/9767227","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_614","dest":"https://download.csdn.net/download/machen_smiling/9767227","strategy":"BlogCommendFromBaidu","index":"9"}'>
		<a href="https://download.csdn.net/download/machen_smiling/9767227" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>MySQL</em><em>体系结构</em>及原理(innodb)图文完美解析					</h4>
					<span class="data float-right">03-01</span>
				</div>
				<div class="desc oneline">
						MySQL体系结构及原理(innodb)图文完美解析				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/GitChat/article/details/78787837","strategy":"BlogCommendFromMachineLearnPai2","index":"10"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/GitChat/article/details/78787837","strategy":"BlogCommendFromMachineLearnPai2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/GitChat/article/details/78787837" target="_blank" title="深入理解 MySQL 底层实现">
		<h4 class="text-truncate oneline">
				深入理解 <em>MySQL</em> 底层实现		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-13</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/GitChat/article/details/78787837" target="_blank" title="深入理解 MySQL 底层实现">
				<span class="desc oneline">本文来自作者 默默 在 GitChat 上分享「深入理解MySQL底层实现」，「阅读原文」查看交流实录。「文末高能」编辑|哈比MySQL的常用引擎1.InnoDBInnoDB的存储文件有两个，后缀名分...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/GitChat">来自：	<span class="blog_title"> GitChat技术杂谈</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_33739523/article/details/85658303","strategy":"BlogCommendFromMachineLearnPai2","index":"11"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_33739523/article/details/85658303","strategy":"BlogCommendFromMachineLearnPai2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33739523/article/details/85658303" target="_blank" title="MySQL运行原理与基础架构">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>运行原理与基础架构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-24</span>
				<span class="read-num hover-hide">
					阅读数 
					29</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33739523/article/details/85658303" target="_blank" title="MySQL运行原理与基础架构">
				<span class="desc oneline">1.MySQL基础MySQL是一个开放源代码的关系数据库管理系统。原开发者为瑞典的MySQLAB公司，最早是在2001年MySQL3.23进入到管理员的视野并在之后获得广泛的应用。2008年MySQL...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33739523">来自：	<span class="blog_title"> weixin_33739523的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/fuzhongmin05/article/details/70904190","strategy":"BlogCommendFromMachineLearnPai2","index":"12"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/fuzhongmin05/article/details/70904190","strategy":"BlogCommendFromMachineLearnPai2","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fuzhongmin05/article/details/70904190" target="_blank" title="MySQL逻辑架构及性能优化原理">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>逻辑架构及性能优化原理		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-28</span>
				<span class="read-num hover-hide">
					阅读数 
					6618</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fuzhongmin05/article/details/70904190" target="_blank" title="MySQL逻辑架构及性能优化原理">
				<span class="desc oneline">说起MySQL的查询优化，相信所有人都了解一些最简单的技巧：不能使用SELECT*、不使用NULL字段、合理创建索引、为字段选择合适的数据类型…..你是否真的理解这些优化技巧？是否理解其背后的工作原理...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fuzhongmin05">来自：	<span class="blog_title"> Hopefully Sky的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/The_Best_Hacker/article/details/82794696","strategy":"BlogCommendFromMachineLearnPai2","index":"13"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/The_Best_Hacker/article/details/82794696","strategy":"BlogCommendFromMachineLearnPai2","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/The_Best_Hacker/article/details/82794696" target="_blank" title="mysql查看表结构的几种方式">
		<h4 class="text-truncate oneline">
				<em>mysql</em>查看表结构的几种方式		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-20</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/The_Best_Hacker/article/details/82794696" target="_blank" title="mysql查看表结构的几种方式">
				<span class="desc oneline">在我第N次忘记如何查看表结构后，在网上查了一下后，看到有好几种查看表结构的方式，总结一下。以student（sid,sname,birthday,sex）的查看为例。【方式一】：descstudent...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/The_Best_Hacker">来自：	<span class="blog_title"> The_Best_Hacker的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/hubo890224/article/details/51837122","strategy":"BlogCommendFromBaidu","index":"14"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/hubo890224/article/details/51837122","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hubo890224/article/details/51837122" target="_blank" title="MySQL体系结构详解——组件">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>体系结构</em>详解——组件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-06</span>
				<span class="read-num hover-hide">
					阅读数 
					2895</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hubo890224/article/details/51837122" target="_blank" title="MySQL体系结构详解——组件">
				<span class="desc oneline">http://www.cnblogs.com/yjf512/archive/2012/02/06/2339496.html了解MySql必须牢牢记住其体系结构图，Mysql是由SQL接口，解析器，优化...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hubo890224">来自：	<span class="blog_title"> hubo890224的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u010993297/article/details/12856581","strategy":"BlogCommendFromBaidu","index":"15"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u010993297/article/details/12856581","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010993297/article/details/12856581" target="_blank" title="Mysql 体系结构系列之十一">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> <em>体系结构</em>系列之十一		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-18</span>
				<span class="read-num hover-hide">
					阅读数 
					834</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010993297/article/details/12856581" target="_blank" title="Mysql 体系结构系列之十一">
				<span class="desc oneline">前言：参考Mysql体系结构系列之十：细看核心模块http://blog.csdn.net/nature_ann/article/details/124416651.细看核心模块DetailedLoo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010993297">来自：	<span class="blog_title"> nature-wb </span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/yiguang_820/article/details/82117210","strategy":"BlogCommendFromBaidu","index":"16"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/yiguang_820/article/details/82117210","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yiguang_820/article/details/82117210" target="_blank" title="1.mysql体系结构">
		<h4 class="text-truncate oneline">
				1.<em>mysql</em><em>体系结构</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-27</span>
				<span class="read-num hover-hide">
					阅读数 
					120</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yiguang_820/article/details/82117210" target="_blank" title="1.mysql体系结构">
				<span class="desc oneline">中文文档：mysql5.1中文文档一.MySql服务器和客户端1.客户端和服务器服务器是指安装mysql的那台机器，而客户端是远程通过网络使用服务器上的mysql，客户端通过得知远程服务器的ip地址以...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yiguang_820">来自：	<span class="blog_title"> yiguang_820的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u010695794/article/details/78908801","strategy":"BlogCommendFromMachineLearnPai2","index":"17"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u010695794/article/details/78908801","strategy":"BlogCommendFromMachineLearnPai2","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010695794/article/details/78908801" target="_blank" title="浅谈MySQL表结构设计">
		<h4 class="text-truncate oneline">
				浅谈<em>MySQL</em>表结构设计		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-27</span>
				<span class="read-num hover-hide">
					阅读数 
					9723</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010695794/article/details/78908801" target="_blank" title="浅谈MySQL表结构设计">
				<span class="desc oneline">本文首发于个人微信公众号《andyqian》，期待你的关注！前言  有一小阵子没有更新技术文章了，今天我们继续MySQL系列，今天要说的是MySQL表结构设计。在我的工作经历当中，就踩过很多这方面的坑...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010695794">来自：	<span class="blog_title"> 划不出的界限</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/chenshun123/article/details/79677037","strategy":"BlogCommendFromMachineLearnPai2","index":"18"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/chenshun123/article/details/79677037","strategy":"BlogCommendFromMachineLearnPai2","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chenshun123/article/details/79677037" target="_blank" title="MySQL 架构及优化原理 详解">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 架构及优化原理 详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-24</span>
				<span class="read-num hover-hide">
					阅读数 
					2721</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chenshun123/article/details/79677037" target="_blank" title="MySQL 架构及优化原理 详解">
				<span class="desc oneline">MySQL逻辑架构MySQL逻辑架构整体分为三层:1&amp;amp;gt; 客户端:并非MySQL所独有，诸如:连接处理、授权认证、安全等功能均在这一层处理2&amp;amp;gt; 核心服务: 包括查询解析、分析...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chenshun123">来自：	<span class="blog_title"> chenshun123的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/cpdiem/article/details/87216421","strategy":"BlogCommendFromMachineLearnPai2","index":"19"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/cpdiem/article/details/87216421","strategy":"BlogCommendFromMachineLearnPai2","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cpdiem/article/details/87216421" target="_blank" title="MySQL体系架构">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>体系架构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-14</span>
				<span class="read-num hover-hide">
					阅读数 
					153</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cpdiem/article/details/87216421" target="_blank" title="MySQL体系架构">
				<span class="desc oneline">数据库管理系统由一个互相关联的数据的集合和一组用以访问这些数据的程序组成。这个数据集合通常称为数据库。一、文件系统的弊端在形成数据库管理系统之前，数据的管理采用一般的文件处理系统。文件处理系统存在以下...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cpdiem">来自：	<span class="blog_title"> cpdiem的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_34043301/article/details/92081137","strategy":"BlogCommendFromMachineLearnPai2","index":"20"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_34043301/article/details/92081137","strategy":"BlogCommendFromMachineLearnPai2","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34043301/article/details/92081137" target="_blank" title="mysql 常用操作">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 常用操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-07</span>
				<span class="read-num hover-hide">
					阅读数 
					4</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34043301/article/details/92081137" target="_blank" title="mysql 常用操作">
				<span class="desc oneline">2019独角兽企业重金招聘Python工程师标准&amp;gt;&amp;gt;&amp;gt;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34043301">来自：	<span class="blog_title"> weixin_34043301的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_39549656/article/details/78999708","strategy":"BlogCommendFromMachineLearnPai2","index":"21"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_39549656/article/details/78999708","strategy":"BlogCommendFromMachineLearnPai2","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_39549656/article/details/78999708" target="_blank" title="浅谈 MySQL 集群高可用架构">
		<h4 class="text-truncate oneline">
				浅谈 <em>MySQL</em> 集群高可用架构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-08</span>
				<span class="read-num hover-hide">
					阅读数 
					252</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_39549656/article/details/78999708" target="_blank" title="浅谈 MySQL 集群高可用架构">
				<span class="desc oneline">浅谈MySQL集群高可用架构点击下载文章原地址http://mp.weixin.qq.com/s/MscsB5K_19MggzB2s5J88g一，前言高可用架构对于互联网服务基本是标配，无论是应用服务...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_39549656">来自：	<span class="blog_title"> 崔崇东的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Maxiao1204/article/details/80588300","strategy":"BlogCommendFromBaidu","index":"22"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Maxiao1204/article/details/80588300","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Maxiao1204/article/details/80588300" target="_blank" title="mysql 体系结构">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>体系结构</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-05</span>
				<span class="read-num hover-hide">
					阅读数 
					143</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Maxiao1204/article/details/80588300" target="_blank" title="mysql 体系结构">
				<span class="desc oneline">学习目标一、MySQL体系结构 二、MySQL内存结构 三、MySQL文件结构 四、Innodb体系结构MySQL体系结构一、MySQL体系结构图1、Mysql是由SQL接口，解析器，优化器，缓存，存...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Maxiao1204">来自：	<span class="blog_title"> 只为成功找方法  不为失败找借口</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/huyangg/article/details/48319175","strategy":"BlogCommendFromBaidu","index":"23"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/huyangg/article/details/48319175","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/huyangg/article/details/48319175" target="_blank" title="MySQL体系结构以及各种文件类型学习汇总">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>体系结构</em>以及各种文件类型学习汇总		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-09</span>
				<span class="read-num hover-hide">
					阅读数 
					310</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/huyangg/article/details/48319175" target="_blank" title="MySQL体系结构以及各种文件类型学习汇总">
				<span class="desc oneline">1，mysql体系结构由数据库和数据库实例组成，是单进场多线程架构。数据库：物理操作系统文件或者其它文件的集合，在mysql中，数据库文件可以是frm、myd、myi、ibd等结尾的文件，当使用ndb...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/huyangg">来自：	<span class="blog_title"> huyangg的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-555","con":",,"}' data-track-click='{"mod":"kp_popu_63-555","con":",,"}' data-report-view='{"mod":"kp_popu_63-555","keyword":""}' data-report-click='{"mod":"kp_popu_63-555","keyword":""}'><div id="three_ad23" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad23",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/KangRoger/article/details/48955779","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/KangRoger/article/details/48955779","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/KangRoger/article/details/48955779" target="_blank" title="MySQL体系结构和存储引擎">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>体系结构</em>和存储引擎		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-07</span>
				<span class="read-num hover-hide">
					阅读数 
					2362</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/KangRoger/article/details/48955779" target="_blank" title="MySQL体系结构和存储引擎">
				<span class="desc oneline">MySQL体制结构和存储引擎介绍</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/KangRoger">来自：	<span class="blog_title"> KangRoger的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u010993297/article/details/12441665","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u010993297/article/details/12441665","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010993297/article/details/12441665" target="_blank" title="Mysql 体系结构系列之十">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> <em>体系结构</em>系列之十		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-08</span>
				<span class="read-num hover-hide">
					阅读数 
					919</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010993297/article/details/12441665" target="_blank" title="Mysql 体系结构系列之十">
				<span class="desc oneline">前言：参考Mysql体系结构系列之九：细看核心模块http://blog.csdn.net/nature_ann/article/details/110679111.细看核心模块DetailedLoo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010993297">来自：	<span class="blog_title"> nature-wb </span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_18312025/article/details/78515305","strategy":"BlogCommendFromMachineLearnPai2","index":"26"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_18312025/article/details/78515305","strategy":"BlogCommendFromMachineLearnPai2","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_18312025/article/details/78515305" target="_blank" title="MySQL数据库体系结构">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库<em>体系结构</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-12</span>
				<span class="read-num hover-hide">
					阅读数 
					3346</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_18312025/article/details/78515305" target="_blank" title="MySQL数据库体系结构">
				<span class="desc oneline">DDL：数据定义语言dataDefinitionlanguage，eg：create、drop、alter；DML：数据操控语言dataManipulationlanguage，eg：insert、u...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_18312025">来自：	<span class="blog_title"> 斯言甚善的笔记</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/linglongwunv/article/details/22890853","strategy":"BlogCommendFromMachineLearnPai2","index":"27"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/linglongwunv/article/details/22890853","strategy":"BlogCommendFromMachineLearnPai2","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/linglongwunv/article/details/22890853" target="_blank" title="【转】mysql 性能优化方案">
		<h4 class="text-truncate oneline">
				【转】<em>mysql</em> 性能优化方案		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-03</span>
				<span class="read-num hover-hide">
					阅读数 
					574</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/linglongwunv/article/details/22890853" target="_blank" title="【转】mysql 性能优化方案">
				<span class="desc oneline">转：http://blog.sae.sina.com.cn/archives/3352内容简介：这是一篇关于mysql性能优化的文章。网上有不少mysql性能优化方案，不过，mysql的优化同sqls...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/linglongwunv">来自：	<span class="blog_title"> 玲珑巫女的学习笔记</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_34306593/article/details/93656615","strategy":"BlogCommendFromMachineLearnPai2","index":"28"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_34306593/article/details/93656615","strategy":"BlogCommendFromMachineLearnPai2","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34306593/article/details/93656615" target="_blank" title="MySQL架构介绍">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>架构介绍		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-04</span>
				<span class="read-num hover-hide">
					阅读数 
					1</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34306593/article/details/93656615" target="_blank" title="MySQL架构介绍">
				<span class="desc oneline">一、MySQL配置文件MySQL的配置文件在Windows下是my.ini文件，在Linux下是etc/my.cnf文件二进制日志文件log-bin——主要作用是用于：主从复制会记录主机上的行（han...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34306593">来自：	<span class="blog_title"> weixin_34306593的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-81","con":",,"}' data-track-click='{"mod":"kp_popu_64-81","con":",,"}' data-report-view='{"mod":"kp_popu_64-81","keyword":""}' data-report-click='{"mod":"kp_popu_64-81","keyword":""}'><div id="three_ad28" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad28",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/rwangnqian/article/details/80021215","strategy":"BlogCommendFromMachineLearnPai2","index":"29"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/rwangnqian/article/details/80021215","strategy":"BlogCommendFromMachineLearnPai2","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/rwangnqian/article/details/80021215" target="_blank" title="mysql体系架构">
		<h4 class="text-truncate oneline">
				<em>mysql</em>体系架构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-20</span>
				<span class="read-num hover-hide">
					阅读数 
					1115</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/rwangnqian/article/details/80021215" target="_blank" title="mysql体系架构">
				<span class="desc oneline">mysql体系结构：   由：连接池组件、管理服务和工具组件、sql接口组件、查询分析器组件、优化器组件、              缓冲组件、插件式存储引擎、物理文件组成。   mysql是独有的插...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/rwangnqian">来自：	<span class="blog_title"> 氤氲紫镜的空间</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/lqx0405/article/details/46818905","strategy":"BlogCommendFromMachineLearnPai2","index":"30"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/lqx0405/article/details/46818905","strategy":"BlogCommendFromMachineLearnPai2","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lqx0405/article/details/46818905" target="_blank" title="MySQL Study之--MySQL体系结构深入解析">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> Study之--<em>MySQL</em><em>体系结构</em>深入解析		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-09</span>
				<span class="read-num hover-hide">
					阅读数 
					6358</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lqx0405/article/details/46818905" target="_blank" title="MySQL Study之--MySQL体系结构深入解析">
				<span class="desc oneline">MySQLStudy之--MySQL体系结构深入解析MySQL体系架构 由:连接池组件、管理服务和⼯工具组件、sql接口组件、查询分析器组件、优化器组件、缓冲组件、插件式存储引擎、物理⽂文件组成。my...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lqx0405">来自：	<span class="blog_title"> 天涯客*Blog</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_33698043/article/details/91922805","strategy":"BlogCommendFromBaidu","index":"31"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_33698043/article/details/91922805","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33698043/article/details/91922805" target="_blank" title="MySQL 存储结构总结">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 存储结构总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-20</span>
				<span class="read-num hover-hide">
					阅读数 
					9</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33698043/article/details/91922805" target="_blank" title="MySQL 存储结构总结">
				<span class="desc oneline">2019独角兽企业重金招聘Python工程师标准&amp;gt;&amp;gt;&amp;gt;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33698043">来自：	<span class="blog_title"> weixin_33698043的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/jh993627471/article/details/79239720","strategy":"BlogCommendFromBaidu","index":"32"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/jh993627471/article/details/79239720","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jh993627471/article/details/79239720" target="_blank" title="mysql-innodb数据页结构">
		<h4 class="text-truncate oneline">
				<em>mysql</em>-innodb数据页结构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-02</span>
				<span class="read-num hover-hide">
					阅读数 
					2410</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jh993627471/article/details/79239720" target="_blank" title="mysql-innodb数据页结构">
				<span class="desc oneline">说明：FileHeader记录页的一些头信息，共占用38字节，组成部分如图：innodb存储引擎中页的类型：PageHeader：记录数据页的状态信息，共占56个字节，组成部分如图：infimum和s...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jh993627471">来自：	<span class="blog_title"> formydream的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/busai2/article/details/89065058","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/busai2/article/details/89065058","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/busai2/article/details/89065058" target="_blank" title="mysql的组成部分">
		<h4 class="text-truncate oneline">
				<em>mysql</em>的组成部分		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-07</span>
				<span class="read-num hover-hide">
					阅读数 
					58</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/busai2/article/details/89065058" target="_blank" title="mysql的组成部分">
				<span class="desc oneline">连接器：负责跟客户端建立连接、获取权限、维持和管理连接wait_timeout：默认8小时客户端无操作断开连接分析器：分析客户端的sql语句有没有语法错误，错误信息在&quot;usenear&quot;附近优化器：优化...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/busai2">来自：	<span class="blog_title"> busai2的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_39034379/article/details/82414402","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_39034379/article/details/82414402","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_39034379/article/details/82414402" target="_blank" title="Mysql组成结构">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>组成结构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-05</span>
				<span class="read-num hover-hide">
					阅读数 
					515</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_39034379/article/details/82414402" target="_blank" title="Mysql组成结构">
				<span class="desc oneline">Mysql组成结构1.体系组成结构Mysql是由SQL接口（SQLInterface）,解析器（Parser）优化器（Optimizer）,缓存（Cache&amp;amp;amp;amp;amp;Buffe...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_39034379">来自：	<span class="blog_title"> weixin_39034379的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/kikajack/article/details/79945900","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/kikajack/article/details/79945900","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/kikajack/article/details/79945900" target="_blank" title="MySQL 架构">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 架构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-15</span>
				<span class="read-num hover-hide">
					阅读数 
					340</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/kikajack/article/details/79945900" target="_blank" title="MySQL 架构">
				<span class="desc oneline">这是《高性能MySQL（第三版）》第一章的读书笔记。1.MySQL逻辑架构在MySQL的架构中，查询处理及其他系统任务跟数据的存储提取相分离。这个特性使得MySQL的用户可以自由选择不同的存储引擎。常...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/kikajack">来自：	<span class="blog_title"> kikajack的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/alexdamiao/article/details/51496267","strategy":"BlogCommendFromMachineLearnPai2","index":"36"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/alexdamiao/article/details/51496267","strategy":"BlogCommendFromMachineLearnPai2","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/alexdamiao/article/details/51496267" target="_blank" title="MySql-体系结构以及各种文件类型">
		<h4 class="text-truncate oneline">
				<em>MySql</em>-<em>体系结构</em>以及各种文件类型		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-25</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/alexdamiao/article/details/51496267" target="_blank" title="MySql-体系结构以及各种文件类型">
				<span class="desc oneline">MySql体系结构由数据库和数据库实例组成，是单进场多线程架构。数据库：物理操作系统文件或者其它文件的集合，数据库文件可以是frm、myd、myi、ibd等结尾的文件。当使用ndb存储引擎时候，不是o...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/alexdamiao">来自：	<span class="blog_title"> alex大喵的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/bwt1989/article/details/87482215","strategy":"BlogCommendFromMachineLearnPai2","index":"37"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/bwt1989/article/details/87482215","strategy":"BlogCommendFromMachineLearnPai2","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/bwt1989/article/details/87482215" target="_blank" title="MySQL的基本架构">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>的基本架构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-16</span>
				<span class="read-num hover-hide">
					阅读数 
					2299</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/bwt1989/article/details/87482215" target="_blank" title="MySQL的基本架构">
				<span class="desc oneline">MySql的基本架构示意图如下：一、MySQL总体上可分为Server层和存储引擎层。Server层包括连接器、查询器、分析器、优化器、执行器等，涵盖MySQL的大多数核心服务功能，以及所有的内置函数...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/bwt1989">来自：	<span class="blog_title"> IT汪的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_26545305/article/details/79674881","strategy":"BlogCommendFromMachineLearnPai2","index":"38"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_26545305/article/details/79674881","strategy":"BlogCommendFromMachineLearnPai2","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_26545305/article/details/79674881" target="_blank" title="Mysql逻辑架构">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>逻辑架构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-31</span>
				<span class="read-num hover-hide">
					阅读数 
					631</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_26545305/article/details/79674881" target="_blank" title="Mysql逻辑架构">
				<span class="desc oneline">   Mysql各个组件之间如何协作，有助于深入理解MySql服务器。   第一层，服务层：为客户端提供服务，如连接处理，授权认证、安全等。   第二层，核心层：MySql的核心服务都在这一层。包括查...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_26545305">来自：	<span class="blog_title"> 柠檬树</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/wulinpingailxr/article/details/80578644","strategy":"BlogCommendFromMachineLearnPai2","index":"39"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/wulinpingailxr/article/details/80578644","strategy":"BlogCommendFromMachineLearnPai2","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wulinpingailxr/article/details/80578644" target="_blank" title="2.mysql体系结构">
		<h4 class="text-truncate oneline">
				2.<em>mysql</em><em>体系结构</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-05</span>
				<span class="read-num hover-hide">
					阅读数 
					164</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wulinpingailxr/article/details/80578644" target="_blank" title="2.mysql体系结构">
				<span class="desc oneline"> 1.mysql体系结构 分为两层：mysqlserver层和存储引擎层 mysqlserver层：连接层和SQL层 连接层：通信协议、线程处理、用户名密码认证 SQL层：权限判断、解析器、预处理、查...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wulinpingailxr">来自：	<span class="blog_title"> wulinpingailxr的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/q402057192/article/details/87689739","strategy":"BlogCommendFromMachineLearnPai2","index":"40"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/q402057192/article/details/87689739","strategy":"BlogCommendFromMachineLearnPai2","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/q402057192/article/details/87689739" target="_blank" title="（一）MySQL体系架构">
		<h4 class="text-truncate oneline">
				（一）<em>MySQL</em>体系架构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-19</span>
				<span class="read-num hover-hide">
					阅读数 
					200</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/q402057192/article/details/87689739" target="_blank" title="（一）MySQL体系架构">
				<span class="desc oneline">（一）MySQL体系架构目录一、MySQL体系结构二、MySQL内存结构三、MySQL文件结构四、Innodb体系结构1.MySQL体系结构由图，可以看出MySQL最上层是连接组件。下面服务器是由连接...</span>
			</a>
			<span class="blog_title_box oneline no-title">
									<span class="type-show type-show-blog type-show-after">博文</span>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_17727449/article/details/52303279","strategy":"BlogCommendFromBaidu","index":"41"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_17727449/article/details/52303279","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_17727449/article/details/52303279" target="_blank" title="MySQL简介">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>简介		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-24</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_17727449/article/details/52303279" target="_blank" title="MySQL简介">
				<span class="desc oneline">MySQL简介与结构图</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_17727449">来自：	<span class="blog_title"> 写给自己看</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/isoleo/article/details/52595637","strategy":"BlogCommendFromBaidu","index":"42"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/isoleo/article/details/52595637","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/isoleo/article/details/52595637" target="_blank" title="Mysql 工作原理">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 工作原理		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-20</span>
				<span class="read-num hover-hide">
					阅读数 
					3169</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/isoleo/article/details/52595637" target="_blank" title="Mysql 工作原理">
				<span class="desc oneline">Mysql工作原理下面先来一张经典的图：  上面的图就是mysql的内部架构，可以清楚的看到Mysql是由SQL接口，解析器，优化器，缓存，存储引擎组成的。 -+-------------------...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/isoleo">来自：	<span class="blog_title"> 李晓蒙的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/kongmin_123/article/details/82055901","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/kongmin_123/article/details/82055901","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/kongmin_123/article/details/82055901" target="_blank" title="Mysql索引数据结构">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>索引数据结构		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-26</span>
				<span class="read-num hover-hide">
					阅读数 
					1434</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/kongmin_123/article/details/82055901" target="_blank" title="Mysql索引数据结构">
				<span class="desc oneline">首先，数据库索引使用树来存储，因为树的查询效率高，而且二叉查找树还可以保持数据的有序。那么索引为什么没有使用二叉树来实现呢？其实从算法逻辑上讲，二叉查找树的查找速度和比较次数都是最小的，但是从Mysq...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/kongmin_123">来自：	<span class="blog_title"> forever-and-ever的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/Simon19950505/article/details/80703027","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Simon19950505/article/details/80703027","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Simon19950505/article/details/80703027" target="_blank" title="mysql结构及sql执行机制">
		<h4 class="text-truncate oneline">
				<em>mysql</em>结构及sql执行机制		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-15</span>
				<span class="read-num hover-hide">
					阅读数 
					231</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Simon19950505/article/details/80703027" target="_blank" title="mysql结构及sql执行机制">
				<span class="desc oneline">mysql内部构架图组件功能sql语句执行过程注意：mysql内部构架图组件功能connectors与外部程序进行交互，如java等；connectionpool管理缓冲用户连接，线程处理等需要缓存的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Simon19950505">来自：	<span class="blog_title"> Simon19950505的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/cfanzp/article/details/45126849","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/cfanzp/article/details/45126849","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cfanzp/article/details/45126849" target="_blank" title="mysql架构组成">
		<h4 class="text-truncate oneline">
				<em>mysql</em>架构组成		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-19</span>
				<span class="read-num hover-hide">
					阅读数 
					263</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cfanzp/article/details/45126849" target="_blank" title="mysql架构组成">
				<span class="desc oneline">mysql系统架构图（来源于互联网）</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cfanzp">来自：	<span class="blog_title"> 游戏人生</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangguanghui002/article/details/78959816","strategy":"BlogCommendFromMachineLearnPai2","index":"46"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangguanghui002/article/details/78959816","strategy":"BlogCommendFromMachineLearnPai2","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhangguanghui002/article/details/78959816" target="_blank" title="MySQL目录结构以及配置文件详解">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>目录结构以及配置文件详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-03</span>
				<span class="read-num hover-hide">
					阅读数 
					5570</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhangguanghui002/article/details/78959816" target="_blank" title="MySQL目录结构以及配置文件详解">
				<span class="desc oneline">昨天给大家进行了数据库介绍，今天将正式带领大家进入我们的课题MySQL讲解部分，首先给大家介绍一下MySQL安装后的目录结构和配置文件详解。一、MySQL的目录结构  1、bin目录       用于...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhangguanghui002">来自：	<span class="blog_title"> zhangguanghui002的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/naruto1021/article/details/7983465","strategy":"BlogCommendFromMachineLearnPai2","index":"47"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/naruto1021/article/details/7983465","strategy":"BlogCommendFromMachineLearnPai2","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/naruto1021/article/details/7983465" target="_blank" title="理解MySQL——架构与概念">
		<h4 class="text-truncate oneline">
				理解<em>MySQL</em>——架构与概念		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-15</span>
				<span class="read-num hover-hide">
					阅读数 
					668</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/naruto1021/article/details/7983465" target="_blank" title="理解MySQL——架构与概念">
				<span class="desc oneline">写在前面：最早接触的MySQL是在三年前，那时候MySQL还是4.x版本，很多功能都不支持，比如，存储过程，视图，触发器，更别说分布式事务等复杂特性了。但从5.0(2005年10月)开始，MySQL渐...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/naruto1021">来自：	<span class="blog_title"> 平常心</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_22167989/article/details/80619671","strategy":"BlogCommendFromMachineLearnPai2","index":"48"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_22167989/article/details/80619671","strategy":"BlogCommendFromMachineLearnPai2","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_22167989/article/details/80619671" target="_blank" title="先码后看 Mysql-索引结构直观图解 侵立删">
		<h4 class="text-truncate oneline">
				先码后看 <em>Mysql</em>-索引结构直观图解 侵立删		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-08</span>
				<span class="read-num hover-hide">
					阅读数 
					27</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_22167989/article/details/80619671" target="_blank" title="先码后看 Mysql-索引结构直观图解 侵立删">
				<span class="desc oneline">转自：https://mp.weixin.qq.com/s/TsS7rMnhY-X7jJUmIpzG1QMysql-索引结构直观图解。上一篇刚刚通俗化的说明了B-TREE的几个结果与存储方式，其实跟索...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_22167989">来自：	<span class="blog_title"> 心神沫沫的收藏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zhengzhaoyang122/article/details/79427165","strategy":"BlogCommendFromMachineLearnPai2","index":"49"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhengzhaoyang122/article/details/79427165","strategy":"BlogCommendFromMachineLearnPai2","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhengzhaoyang122/article/details/79427165" target="_blank" title="Mysql高级架构介绍">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>高级架构介绍		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-04</span>
				<span class="read-num hover-hide">
					阅读数 
					1460</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhengzhaoyang122/article/details/79427165" target="_blank" title="Mysql高级架构介绍">
				<span class="desc oneline">1、Mysql简介：    (1)概述：①、MySQL是一个关系型数据库管理系统，由瑞典MySQLAB公司开发，目前属于Oracle公司。                 ②、MySQL是一种关联数据...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhengzhaoyang122">来自：	<span class="blog_title"> zhengzhaoxiang的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/OtTaAgxsMS1lZHUO0O0O.html" target="_blank">
                        人工智能的课程体系结构</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtTaAgwsODktZWR1.html" target="_blank">
                        大数据课程的体系结构</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/da_guo_li">
              <img src="https://avatar.csdn.net/D/8/9/3_da_guo_li.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/3.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/da_guo_li"  class="" id="uid">da_guo_li</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="29">
                        <dt><a href="https://blog.csdn.net/da_guo_li?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/da_guo_li?t=1"><span class="count">29</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="19">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">19</span></dd>
        </dl>
        <dl class="text-center" title="20">
            <dt>喜欢</dt>
            <dd><span class="count">20</span></dd>
        </dl>
        <dl class="text-center" title="9">
            <dt>评论</dt>
            <dd><span class="count">9</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="3级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-3"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="43903">
                4万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="691">
                691            </dd>
        </dl>
        <dl title="107944">
            <dt>排名：</dt>
            <dd>10万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/da_guo_li">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/da_guo_li/article/details/80212382" target="_blank" >
                                        【JavaSE】Java包装类型的Cache机制                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/da_guo_li/article/details/79115695" target="_blank" >
                                        【Laravel】Eloquent ORM的底层实现                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/da_guo_li/article/details/79011718" target="_blank" >
                                        【MySQL】MySQL数据类型宽度                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/da_guo_li/article/details/79008457" target="_blank" >
                                        【MySQL】常见的业务处理-删除重复数据                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/da_guo_li/article/details/79008451" target="_blank" >
                                        【MySQL】常见的业务处理-分页显示                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/da_guo_li/article/category/6372359">
                    <span class="title oneline">&gt;&gt;JAVASE&lt;&lt;</span>
                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/da_guo_li/article/category/6372360">
                    <span class="title oneline">&gt;&gt;JAVAWEB&lt;&lt;</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/da_guo_li/article/category/6952330">
                    <span class="title oneline">&gt;&gt;数据结构与算法&lt;&lt;</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/da_guo_li/article/category/6952363">
                    <span class="title oneline">&gt;&gt;JVM&lt;&lt;</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/da_guo_li/article/category/6955021">
                    <span class="title oneline">&gt;&gt;设计模式&lt;&lt;</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/da_guo_li/article/category/6960222">
                    <span class="title oneline">&gt;&gt;网络爬虫&lt;&lt;</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/da_guo_li/article/category/6967640">
                    <span class="title oneline">&gt;&gt;OOD&lt;&lt;</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/da_guo_li/article/category/7310301">
                    <span class="title oneline">&gt;&gt;PHP&lt;&lt;</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/da_guo_li/article/category/7387396">
                    <span class="title oneline">&gt;&gt;数据库&lt;&lt;</span>
                    <span class="count float-right">7篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/da_guo_li/article/month/2018/05">
                    2018年5月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/da_guo_li/article/month/2018/01">
                    2018年1月                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/da_guo_li/article/month/2017/12">
                    2017年12月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/da_guo_li/article/month/2017/11">
                    2017年11月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/da_guo_li/article/month/2017/10">
                    2017年10月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/da_guo_li/article/month/2017/09">
                    2017年9月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/da_guo_li/article/month/2017/06">
                    2017年6月                    <span class="count float-right">16篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/da_guo_li/article/details/79008016" >
                                                【MySQL】SQL执行计划分析                    </a>
					<p class="read">阅读数 <span>14758</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/da_guo_li/article/details/73250291" >
                                                Spring 在静态工具类中使用注解注入bean                    </a>
					<p class="read">阅读数 <span>6153</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/da_guo_li/article/details/79008418" >
                                                【MySQL】常见的业务处理-进行分区间的统计                    </a>
					<p class="read">阅读数 <span>3125</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/da_guo_li/article/details/80280289" >
                                                【MySQL】漫谈MySQL体系结构                    </a>
					<p class="read">阅读数 <span>3032</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/da_guo_li/article/details/78857894" >
                                                【Laravel】数据库事务                    </a>
					<p class="read">阅读数 <span>2695</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/da_guo_li/article/details/80280289#comments">【MySQL】漫谈MySQL体系结构</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/zhangzhemin_9014" class="user-name" target="_blank">zhangzhemin_9014：</a>[reply]xieqinzhangjian[/reply]
你等会?大小写这么重要么?                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/da_guo_li/article/details/80280289#comments">【MySQL】漫谈MySQL体系结构</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/xieqinzhangjian" class="user-name" target="_blank">xieqinzhangjian：</a>文章写错了，建立MyISAM表的时候用了Myisam了                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/da_guo_li/article/details/80280289#comments">【MySQL】漫谈MySQL体系结构</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/weixin_44869080" class="user-name" target="_blank">weixin_44869080：</a>谢谢谢谢谢谢谢谢谢谢                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/da_guo_li/article/details/80280289#comments">【MySQL】漫谈MySQL体系结构</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/weixin_44869080" class="user-name" target="_blank">weixin_44869080：</a>谢谢谢谢谢谢谢谢谢谢                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/da_guo_li/article/details/79008016#comments">【MySQL】SQL执行计划分析</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/liuyangan2008" class="user-name" target="_blank">liuyangan2008：</a>[reply]David_bdqn[/reply]
哈哈，同感                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box long-width">
			<button class=" long-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">9</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments long-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
						5				</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/da_guo_li/article/details/80212382" title="【JavaSE】Java包装类型的Cache机制">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/da_guo_li/article/details/80212382" title="【JavaSE】Java包装类型的Cache机制">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
											</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "80280289";
    var commentscount = 5;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/da_guo_li/article/details/80280289";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "【MySQL】漫谈MySQL体系结构 - 多多说happy的博客";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u6f2b\u8c08","mysql","\u4f53\u7cfb\u7ed3\u6784"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

<!-- 高亮未与 markdown兼容  -->
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/chart.css" />
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/lib/chart.min.js"></script>
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/widget2chart.js"></script>
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
